What is the purpose of using COLLATE in a query?

Question

hanmandlu vasani · Answer

Amit Singh · Answer

The term, collation, refers to a set of rules that determine
how data is sorted and compared. In Microsoft? SQL Server
2000, it is not required to separately specify code page and
sort order for character data, and the collation used for
Unicode data. Instead, specify the collation name and
sorting rules to use.

Amit Singh · Answer

COLLATE is a clause that can be applied to a database definition or a 
column definition to define the collation, or to a character string 
expression to apply a collation cast.

Amit Singh · Answer

Collation refers to a set of rules that determine how data is sorted and
 compared. Character data is sorted using rules that define the correct 
character sequence, with options for specifying case-sensitivity, accent
 marks, kana character types and character width.

interview

What is the purpose of using COLLATE in a query?

Amit Singh

Can you answer this question?

4 Answers

Liked By